Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 105987 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 31.9 MiB |
| Average record size in memory | 315.8 B |
Variable types
| Text | 3 |
|---|---|
| Numeric | 7 |
| DateTime | 1 |
dom_basis is highly overall correlated with dom_basis_rate and 2 other fields | High correlation |
dom_basis_rate is highly overall correlated with dom_basis and 2 other fields | High correlation |
dominant_contract_price is highly overall correlated with near_contract_price and 1 other fields | High correlation |
near_basis is highly overall correlated with dom_basis and 2 other fields | High correlation |
near_basis_rate is highly overall correlated with dom_basis and 2 other fields | High correlation |
near_contract_price is highly overall correlated with dominant_contract_price and 1 other fields | High correlation |
spot_price is highly overall correlated with dominant_contract_price and 1 other fields | High correlation |
Reproduction
| Analysis started | 2024-03-21 02:18:50.716177 |
|---|---|
| Analysis finished | 2024-03-21 02:19:06.994781 |
| Duration | 16.28 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
variety
Text
| Distinct | 51 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 5.9 MiB |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 1.7968147 |
| Min length | 1 |
Characters and Unicode
| Total characters | 190439 |
|---|---|
| Distinct characters | 23 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | C |
|---|---|
| 2nd row | A |
| 3rd row | M |
| 4th row | Y |
| 5th row | P |
| Value | Count | Frequency (%) |
| c | 2715 | 2.6% |
| y | 2715 | 2.6% |
| p | 2715 | 2.6% |
| l | 2715 | 2.6% |
| v | 2715 | 2.6% |
| a | 2715 | 2.6% |
| m | 2715 | 2.6% |
| au | 2714 | 2.6% |
| cu | 2714 | 2.6% |
| zn | 2714 | 2.6% |
| Other values (41) | 78840 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 19022 | 10.0% |
| R | 17385 | 9.1% |
| A | 16850 | 8.8% |
| P | 16092 | 8.4% |
| C | 14542 | 7.6% |
| U | 14486 | 7.6% |
| M | 12819 | 6.7% |
| F | 11271 | 5.9% |
| B | 9191 | 4.8% |
| G | 7657 | 4.0% |
| Other values (13) | 51124 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 190439 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| S | 19022 | 10.0% |
| R | 17385 | 9.1% |
| A | 16850 | 8.8% |
| P | 16092 | 8.4% |
| C | 14542 | 7.6% |
| U | 14486 | 7.6% |
| M | 12819 | 6.7% |
| F | 11271 | 5.9% |
| B | 9191 | 4.8% |
| G | 7657 | 4.0% |
| Other values (13) | 51124 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 190439 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| S | 19022 | 10.0% |
| R | 17385 | 9.1% |
| A | 16850 | 8.8% |
| P | 16092 | 8.4% |
| C | 14542 | 7.6% |
| U | 14486 | 7.6% |
| M | 12819 | 6.7% |
| F | 11271 | 5.9% |
| B | 9191 | 4.8% |
| G | 7657 | 4.0% |
| Other values (13) | 51124 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 190439 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| S | 19022 | 10.0% |
| R | 17385 | 9.1% |
| A | 16850 | 8.8% |
| P | 16092 | 8.4% |
| C | 14542 | 7.6% |
| U | 14486 | 7.6% |
| M | 12819 | 6.7% |
| F | 11271 | 5.9% |
| B | 9191 | 4.8% |
| G | 7657 | 4.0% |
| Other values (13) | 51124 |
spot_price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 32537 |
|---|---|
| Distinct (%) | 30.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13688.09 |
| Minimum | 11.2 |
|---|---|
| Maximum | 368475 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 828.1 KiB |
Quantile statistics
| Minimum | 11.2 |
|---|---|
| 5-th percentile | 840 |
| Q1 | 3063.12 |
| median | 5278 |
| Q3 | 9604.585 |
| 95-th percentile | 57831 |
| Maximum | 368475 |
| Range | 368463.8 |
| Interquartile range (IQR) | 6541.465 |
Descriptive statistics
| Standard deviation | 31342.95 |
|---|---|
| Coefficient of variation (CV) | 2.2897972 |
| Kurtosis | 30.731529 |
| Mean | 13688.09 |
| Median Absolute Deviation (MAD) | 2688 |
| Skewness | 5.112544 |
| Sum | 1.4507596 × 109 |
| Variance | 9.8238054 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 5100 | 190 | 0.2% |
| 4400 | 117 | 0.1% |
| 5400 | 105 | 0.1% |
| 5200 | 92 | 0.1% |
| 4600 | 91 | 0.1% |
| 3750 | 91 | 0.1% |
| 5600 | 85 | 0.1% |
| 2433.33 | 85 | 0.1% |
| 5300 | 83 | 0.1% |
| 5500 | 82 | 0.1% |
| Other values (32527) | 104966 |
| Value | Count | Frequency (%) |
| 11.2 | 1 | |
| 11.28 | 2 | |
| 11.33 | 1 | |
| 11.5 | 1 | |
| 11.62 | 1 | |
| 11.63 | 1 | |
| 11.8 | 1 | |
| 11.87 | 1 | |
| 11.9 | 2 | |
| 11.92 | 1 |
| Value | Count | Frequency (%) |
| 368475 | 1 | |
| 355162.5 | 1 | |
| 351350 | 1 | |
| 351225 | 1 | |
| 350975 | 1 | |
| 350350 | 1 | |
| 350162.5 | 1 | |
| 349537.5 | 2 | |
| 347912.5 | 2 | |
| 347350 | 1 |
near_contract
Text
| Distinct | 4370 |
|---|---|
| Distinct (%) | 4.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.3 MiB |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.476917 |
| Min length | 4 |
Characters and Unicode
| Total characters | 580482 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 16 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | c1301 |
|---|---|
| 2nd row | a1301 |
| 3rd row | m1301 |
| 4th row | y1301 |
| 5th row | p1301 |
| Value | Count | Frequency (%) |
| ma506 | 244 | 0.2% |
| rs407 | 239 | 0.2% |
| lh2109 | 175 | 0.2% |
| rs607 | 163 | 0.2% |
| oi307 | 163 | 0.2% |
| rs507 | 162 | 0.2% |
| rs107 | 162 | 0.2% |
| rs307 | 162 | 0.2% |
| rs807 | 162 | 0.2% |
| rs707 | 161 | 0.2% |
| Other values (4319) | 104194 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 99186 | |
| 1 | 96630 | |
| 2 | 56003 | 9.6% |
| 3 | 27728 | 4.8% |
| 7 | 21406 | 3.7% |
| 9 | 20933 | 3.6% |
| 5 | 19383 | 3.3% |
| 4 | 17102 | 2.9% |
| 8 | 16401 | 2.8% |
| 6 | 15271 | 2.6% |
| Other values (37) | 190439 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 580482 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 99186 | |
| 1 | 96630 | |
| 2 | 56003 | 9.6% |
| 3 | 27728 | 4.8% |
| 7 | 21406 | 3.7% |
| 9 | 20933 | 3.6% |
| 5 | 19383 | 3.3% |
| 4 | 17102 | 2.9% |
| 8 | 16401 | 2.8% |
| 6 | 15271 | 2.6% |
| Other values (37) | 190439 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 580482 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 99186 | |
| 1 | 96630 | |
| 2 | 56003 | 9.6% |
| 3 | 27728 | 4.8% |
| 7 | 21406 | 3.7% |
| 9 | 20933 | 3.6% |
| 5 | 19383 | 3.3% |
| 4 | 17102 | 2.9% |
| 8 | 16401 | 2.8% |
| 6 | 15271 | 2.6% |
| Other values (37) | 190439 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 580482 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 99186 | |
| 1 | 96630 | |
| 2 | 56003 | 9.6% |
| 3 | 27728 | 4.8% |
| 7 | 21406 | 3.7% |
| 9 | 20933 | 3.6% |
| 5 | 19383 | 3.3% |
| 4 | 17102 | 2.9% |
| 8 | 16401 | 2.8% |
| 6 | 15271 | 2.6% |
| Other values (37) | 190439 |
near_contract_price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 19681 |
|---|---|
| Distinct (%) | 18.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13547.08 |
| Minimum | 0 |
|---|---|
| Maximum | 370200 |
| Zeros | 19 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 828.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1010 |
| Q1 | 2940 |
| median | 5206 |
| Q3 | 9922 |
| 95-th percentile | 57767 |
| Maximum | 370200 |
| Range | 370200 |
| Interquartile range (IQR) | 6982 |
Descriptive statistics
| Standard deviation | 30846.682 |
|---|---|
| Coefficient of variation (CV) | 2.2769986 |
| Kurtosis | 30.530684 |
| Mean | 13547.08 |
| Median Absolute Deviation (MAD) | 2670 |
| Skewness | 5.0916011 |
| Sum | 1.4358143 × 109 |
| Variance | 9.5151778 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3122 | 284 | 0.3% |
| 3198 | 135 | 0.1% |
| 3317 | 132 | 0.1% |
| 2507 | 99 | 0.1% |
| 2309 | 97 | 0.1% |
| 2350 | 96 | 0.1% |
| 4800 | 95 | 0.1% |
| 3121 | 93 | 0.1% |
| 2340 | 81 | 0.1% |
| 2500 | 76 | 0.1% |
| Other values (19671) | 104799 |
| Value | Count | Frequency (%) |
| 0 | 19 | |
| 214.95 | 2 | < 0.1% |
| 215.95 | 1 | < 0.1% |
| 216 | 2 | < 0.1% |
| 216.4 | 1 | < 0.1% |
| 216.55 | 1 | < 0.1% |
| 217.1 | 1 | < 0.1% |
| 217.3 | 1 | < 0.1% |
| 217.5 | 1 | < 0.1% |
| 217.8 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 370200 | 1 | |
| 355130 | 1 | |
| 352990 | 1 | |
| 349700 | 1 | |
| 349200 | 1 | |
| 348350 | 1 | |
| 348290 | 1 | |
| 347860 | 1 | |
| 347770 | 1 | |
| 346050 | 1 |
| Distinct | 2066 |
|---|---|
| Distinct (%) | 1.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.3 MiB |
Length
| Max length | 6 |
|---|---|
| Median length | 5 |
| Mean length | 5.4768792 |
| Min length | 4 |
Characters and Unicode
| Total characters | 580478 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 33 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | c1305 |
|---|---|
| 2nd row | a1305 |
| 3rd row | m1305 |
| 4th row | y1305 |
| 5th row | p1305 |
| Value | Count | Frequency (%) |
| rs409 | 245 | 0.2% |
| pm007 | 240 | 0.2% |
| rs311 | 223 | 0.2% |
| ma506 | 203 | 0.2% |
| rs607 | 201 | 0.2% |
| wh303 | 200 | 0.2% |
| rs909 | 176 | 0.2% |
| wr1504 | 176 | 0.2% |
| rs507 | 176 | 0.2% |
| ta401 | 175 | 0.2% |
| Other values (2023) | 103972 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 108900 | |
| 1 | 89970 | |
| 2 | 52340 | 9.0% |
| 9 | 34867 | 6.0% |
| 5 | 33972 | 5.9% |
| 3 | 17698 | 3.0% |
| 4 | 14651 | 2.5% |
| 6 | 14182 | 2.4% |
| u | 13381 | 2.3% |
| p | 13265 | 2.3% |
| Other values (37) | 187252 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 580478 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 108900 | |
| 1 | 89970 | |
| 2 | 52340 | 9.0% |
| 9 | 34867 | 6.0% |
| 5 | 33972 | 5.9% |
| 3 | 17698 | 3.0% |
| 4 | 14651 | 2.5% |
| 6 | 14182 | 2.4% |
| u | 13381 | 2.3% |
| p | 13265 | 2.3% |
| Other values (37) | 187252 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 580478 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 108900 | |
| 1 | 89970 | |
| 2 | 52340 | 9.0% |
| 9 | 34867 | 6.0% |
| 5 | 33972 | 5.9% |
| 3 | 17698 | 3.0% |
| 4 | 14651 | 2.5% |
| 6 | 14182 | 2.4% |
| u | 13381 | 2.3% |
| p | 13265 | 2.3% |
| Other values (37) | 187252 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 580478 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 108900 | |
| 1 | 89970 | |
| 2 | 52340 | 9.0% |
| 9 | 34867 | 6.0% |
| 5 | 33972 | 5.9% |
| 3 | 17698 | 3.0% |
| 4 | 14651 | 2.5% |
| 6 | 14182 | 2.4% |
| u | 13381 | 2.3% |
| p | 13265 | 2.3% |
| Other values (37) | 187252 |
dominant_contract_price
Real number (ℝ)
HIGH CORRELATION
| Distinct | 20889 |
|---|---|
| Distinct (%) | 19.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13536.419 |
| Minimum | 0 |
|---|---|
| Maximum | 371700 |
| Zeros | 12 |
| Zeros (%) | < 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 828.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 938 |
| Q1 | 2952 |
| median | 5180 |
| Q3 | 9710 |
| 95-th percentile | 57984 |
| Maximum | 371700 |
| Range | 371700 |
| Interquartile range (IQR) | 6758 |
Descriptive statistics
| Standard deviation | 30760.708 |
|---|---|
| Coefficient of variation (CV) | 2.2724405 |
| Kurtosis | 29.895941 |
| Mean | 13536.419 |
| Median Absolute Deviation (MAD) | 2626 |
| Skewness | 5.0489894 |
| Sum | 1.4346845 × 109 |
| Variance | 9.4622113 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3122 | 411 | 0.4% |
| 3198 | 269 | 0.3% |
| 3748 | 172 | 0.2% |
| 3121 | 171 | 0.2% |
| 2512 | 103 | 0.1% |
| 2230 | 88 | 0.1% |
| 2676 | 87 | 0.1% |
| 2550 | 80 | 0.1% |
| 2330 | 71 | 0.1% |
| 2514 | 71 | 0.1% |
| Other values (20879) | 104464 |
| Value | Count | Frequency (%) |
| 0 | 12 | |
| 218.75 | 1 | < 0.1% |
| 219.25 | 1 | < 0.1% |
| 219.45 | 2 | < 0.1% |
| 219.6 | 1 | < 0.1% |
| 219.7 | 1 | < 0.1% |
| 219.95 | 1 | < 0.1% |
| 220.3 | 1 | < 0.1% |
| 220.6 | 1 | < 0.1% |
| 220.75 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 371700 | 1 | |
| 355630 | 1 | |
| 352500 | 1 | |
| 349470 | 1 | |
| 346340 | 1 | |
| 345950 | 1 | |
| 345820 | 1 | |
| 345770 | 1 | |
| 344010 | 1 | |
| 342690 | 1 |
near_basis
Real number (ℝ)
HIGH CORRELATION
| Distinct | 25187 |
|---|---|
| Distinct (%) | 23.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 141.01023 |
| Minimum | -29072.03 |
|---|---|
| Maximum | 93450 |
| Zeros | 342 |
| Zeros (%) | 0.3% |
| Negative | 34901 |
| Negative (%) | 32.9% |
| Memory size | 828.1 KiB |
Quantile statistics
| Minimum | -29072.03 |
|---|---|
| 5-th percentile | -420 |
| Q1 | -32 |
| median | 77.67 |
| Q3 | 284 |
| 95-th percentile | 1470 |
| Maximum | 93450 |
| Range | 122522.03 |
| Interquartile range (IQR) | 316 |
Descriptive statistics
| Standard deviation | 2105.0262 |
|---|---|
| Coefficient of variation (CV) | 14.928181 |
| Kurtosis | 278.67538 |
| Mean | 141.01023 |
| Median Absolute Deviation (MAD) | 147.67 |
| Skewness | 2.9118818 |
| Sum | 14945251 |
| Variance | 4431135.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 342 | 0.3% |
| 10 | 304 | 0.3% |
| 20 | 292 | 0.3% |
| 50 | 273 | 0.3% |
| 100 | 260 | 0.2% |
| -10 | 260 | 0.2% |
| 40 | 254 | 0.2% |
| 60 | 241 | 0.2% |
| 70 | 239 | 0.2% |
| 90 | 239 | 0.2% |
| Other values (25177) | 103283 |
| Value | Count | Frequency (%) |
| -29072.03 | 1 | |
| -28956.9 | 1 | |
| -28881.32 | 1 | |
| -28847.28 | 1 | |
| -28831.55 | 1 | |
| -28802.1 | 1 | |
| -28736.32 | 1 | |
| -28725.7 | 1 | |
| -28671.97 | 1 | |
| -28606.3 | 1 |
| Value | Count | Frequency (%) |
| 93450 | 1 | |
| 83900 | 1 | |
| 82550 | 1 | |
| 72950 | 1 | |
| 70700 | 1 | |
| 70550 | 1 | |
| 67400 | 1 | |
| 65550 | 1 | |
| 62700 | 1 | |
| 61000 | 1 |
dom_basis
Real number (ℝ)
HIGH CORRELATION
| Distinct | 27707 |
|---|---|
| Distinct (%) | 26.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 151.6708 |
| Minimum | -29072.03 |
|---|---|
| Maximum | 93450 |
| Zeros | 204 |
| Zeros (%) | 0.2% |
| Negative | 39263 |
| Negative (%) | 37.0% |
| Memory size | 828.1 KiB |
Quantile statistics
| Minimum | -29072.03 |
|---|---|
| 5-th percentile | -536 |
| Q1 | -65.67 |
| median | 79 |
| Q3 | 343 |
| 95-th percentile | 1540 |
| Maximum | 93450 |
| Range | 122522.03 |
| Interquartile range (IQR) | 408.67 |
Descriptive statistics
| Standard deviation | 2189.5453 |
|---|---|
| Coefficient of variation (CV) | 14.436169 |
| Kurtosis | 239.45275 |
| Mean | 151.6708 |
| Median Absolute Deviation (MAD) | 188.33 |
| Skewness | 2.3285325 |
| Sum | 16075133 |
| Variance | 4794108.8 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 204 | 0.2% |
| 10 | 191 | 0.2% |
| 20 | 182 | 0.2% |
| 90 | 182 | 0.2% |
| 140 | 182 | 0.2% |
| -10 | 179 | 0.2% |
| -40 | 177 | 0.2% |
| 50 | 175 | 0.2% |
| 40 | 174 | 0.2% |
| -30 | 170 | 0.2% |
| Other values (27697) | 104171 |
| Value | Count | Frequency (%) |
| -29072.03 | 1 | |
| -28956.9 | 1 | |
| -28881.32 | 1 | |
| -28847.28 | 1 | |
| -28831.55 | 1 | |
| -28802.1 | 1 | |
| -28736.32 | 1 | |
| -28725.7 | 1 | |
| -28671.97 | 1 | |
| -28606.3 | 1 |
| Value | Count | Frequency (%) |
| 93450 | 1 | |
| 83900 | 1 | |
| 82550 | 1 | |
| 72950 | 1 | |
| 70700 | 1 | |
| 70550 | 1 | |
| 67400 | 1 | |
| 65550 | 1 | |
| 62700 | 1 | |
| 61000 | 1 |
near_basis_rate
Real number (ℝ)
HIGH CORRELATION
| Distinct | 89448 |
|---|---|
| Distinct (%) | 84.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -7.1464508 |
| Minimum | -1410.5414 |
|---|---|
| Maximum | 1 |
| Zeros | 342 |
| Zeros (%) | 0.3% |
| Negative | 34901 |
| Negative (%) | 32.9% |
| Memory size | 828.1 KiB |
Quantile statistics
| Minimum | -1410.5414 |
|---|---|
| 5-th percentile | -0.080362392 |
| Q1 | -0.005935564 |
| median | 0.012048193 |
| Q3 | 0.045703488 |
| 95-th percentile | 0.14871389 |
| Maximum | 1 |
| Range | 1411.5414 |
| Interquartile range (IQR) | 0.051639052 |
Descriptive statistics
| Standard deviation | 84.494673 |
|---|---|
| Coefficient of variation (CV) | -11.823306 |
| Kurtosis | 140.4337 |
| Mean | -7.1464508 |
| Median Absolute Deviation (MAD) | 0.025112096 |
| Skewness | -11.852332 |
| Sum | -757430.88 |
| Variance | 7139.3497 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 342 | 0.3% |
| 0.02857142857 | 30 | < 0.1% |
| 0.04 | 22 | < 0.1% |
| 1 | 19 | < 0.1% |
| 0.01428571429 | 18 | < 0.1% |
| 0.006984627116 | 18 | < 0.1% |
| 0.025 | 17 | < 0.1% |
| -0.05 | 17 | < 0.1% |
| -0.337254902 | 17 | < 0.1% |
| 0.02 | 17 | < 0.1% |
| Other values (89438) | 105470 |
| Value | Count | Frequency (%) |
| -1410.541382 | 1 | |
| -1382.076923 | 1 | |
| -1356.307692 | 1 | |
| -1333.399431 | 1 | |
| -1329.666667 | 1 | |
| -1327.33217 | 1 | |
| -1311.785388 | 1 | |
| -1302.767123 | 1 | |
| -1302.664921 | 1 | |
| -1301.903226 | 1 |
| Value | Count | Frequency (%) |
| 1 | 19 | |
| 0.7216438356 | 1 | < 0.1% |
| 0.7087912088 | 1 | < 0.1% |
| 0.6821917808 | 1 | < 0.1% |
| 0.681043956 | 1 | < 0.1% |
| 0.6777353082 | 1 | < 0.1% |
| 0.6765136719 | 1 | < 0.1% |
| 0.6696082652 | 1 | < 0.1% |
| 0.6679616088 | 1 | < 0.1% |
| 0.6627326373 | 1 | < 0.1% |
dom_basis_rate
Real number (ℝ)
HIGH CORRELATION
| Distinct | 96656 |
|---|---|
| Distinct (%) | 91.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -7.5567127 |
| Minimum | -1420.8382 |
|---|---|
| Maximum | 1 |
| Zeros | 204 |
| Zeros (%) | 0.2% |
| Negative | 39263 |
| Negative (%) | 37.0% |
| Memory size | 828.1 KiB |
Quantile statistics
| Minimum | -1420.8382 |
|---|---|
| 5-th percentile | -0.08535405 |
| Q1 | -0.011368997 |
| median | 0.012995006 |
| Q3 | 0.055152055 |
| 95-th percentile | 0.17506269 |
| Maximum | 1 |
| Range | 1421.8382 |
| Interquartile range (IQR) | 0.066521052 |
Descriptive statistics
| Standard deviation | 89.548429 |
|---|---|
| Coefficient of variation (CV) | -11.850183 |
| Kurtosis | 141.97501 |
| Mean | -7.5567127 |
| Median Absolute Deviation (MAD) | 0.031764188 |
| Skewness | -11.909688 |
| Sum | -800913.31 |
| Variance | 8018.9211 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 204 | 0.2% |
| 0.1 | 20 | < 0.1% |
| 0.03333333333 | 20 | < 0.1% |
| -0.0731372549 | 17 | < 0.1% |
| 0.02 | 17 | < 0.1% |
| 0.08995983936 | 16 | < 0.1% |
| 0.0661641541 | 16 | < 0.1% |
| 0.03661202186 | 15 | < 0.1% |
| 0.05433057555 | 15 | < 0.1% |
| 0.07660961695 | 14 | < 0.1% |
| Other values (96646) | 105633 |
| Value | Count | Frequency (%) |
| -1420.838178 | 1 | |
| -1410.541382 | 1 | |
| -1394.2 | 1 | |
| -1385.590038 | 1 | |
| -1382.076923 | 1 | |
| -1358.042553 | 1 | |
| -1356.307692 | 1 | |
| -1350.012146 | 1 | |
| -1333.767642 | 1 | |
| -1333.399431 | 1 |
| Value | Count | Frequency (%) |
| 1 | 12 | |
| 0.6700907788 | 1 | < 0.1% |
| 0.658820841 | 1 | < 0.1% |
| 0.6579589844 | 1 | < 0.1% |
| 0.6571244081 | 1 | < 0.1% |
| 0.6504766228 | 1 | < 0.1% |
| 0.6503656307 | 1 | < 0.1% |
| 0.6494169096 | 1 | < 0.1% |
| 0.6485374771 | 1 | < 0.1% |
| 0.6453170937 | 1 | < 0.1% |
date
Date
| Distinct | 2715 |
|---|---|
| Distinct (%) | 2.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 828.1 KiB |
| Minimum | 2013-01-04 00:00:00 |
|---|---|
| Maximum | 2024-03-11 00:00:00 |
Histogram with fixed size bins (bins=50)
| dom_basis | dom_basis_rate | dominant_contract_price | near_basis | near_basis_rate | near_contract_price | spot_price | |
|---|---|---|---|---|---|---|---|
| dom_basis | 1.000 | 0.900 | 0.109 | 0.691 | 0.616 | 0.137 | 0.237 |
| dom_basis_rate | 0.900 | 1.000 | -0.110 | 0.609 | 0.668 | -0.079 | 0.028 |
| dominant_contract_price | 0.109 | -0.110 | 1.000 | 0.162 | -0.096 | 0.997 | 0.956 |
| near_basis | 0.691 | 0.609 | 0.162 | 1.000 | 0.896 | 0.150 | 0.268 |
| near_basis_rate | 0.616 | 0.668 | -0.096 | 0.896 | 1.000 | -0.108 | 0.017 |
| near_contract_price | 0.137 | -0.079 | 0.997 | 0.150 | -0.108 | 1.000 | 0.958 |
| spot_price | 0.237 | 0.028 | 0.956 | 0.268 | 0.017 | 0.958 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| variety | spot_price | near_contract | near_contract_price | dominant_contract | dominant_contract_price | near_basis | dom_basis | near_basis_rate | dom_basis_rate | date | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | C | 2330.45 | c1301 | 2330.0 | c1305 | 2443.0 | 0.45 | -112.55 | 0.000193 | -0.048295 | 2013-01-04 00:00:00 |
| 1 | A | 4520.00 | a1301 | 4590.0 | a1305 | 4730.0 | -70.00 | -210.00 | -0.015487 | -0.046460 | 2013-01-04 00:00:00 |
| 2 | M | 3963.00 | m1301 | 3813.0 | m1305 | 3241.0 | 150.00 | 722.00 | 0.037850 | 0.182185 | 2013-01-04 00:00:00 |
| 3 | Y | 8990.00 | y1301 | 9090.0 | y1305 | 8722.0 | -100.00 | 268.00 | -0.011123 | 0.029811 | 2013-01-04 00:00:00 |
| 4 | P | 6312.50 | p1301 | 6258.0 | p1305 | 7000.0 | 54.50 | -687.50 | 0.008634 | -0.108911 | 2013-01-04 00:00:00 |
| 5 | L | 11216.67 | l1301 | 11370.0 | l1305 | 10880.0 | -153.33 | 336.67 | -0.013670 | 0.030015 | 2013-01-04 00:00:00 |
| 6 | V | 6486.57 | v1301 | 6355.0 | v1305 | 6685.0 | 131.57 | -198.43 | 0.020283 | -0.030591 | 2013-01-04 00:00:00 |
| 7 | PM | 2503.33 | pm301 | 2520.0 | pm309 | 2498.0 | -16.67 | 5.33 | -0.006659 | 0.002129 | 2013-01-04 00:00:00 |
| 8 | CF | 19158.25 | cf301 | 20000.0 | cf305 | 19005.0 | -841.75 | 153.25 | -0.043937 | 0.007999 | 2013-01-04 00:00:00 |
| 9 | SR | 5984.00 | SR301 | 5659.0 | SR305 | 5567.0 | 325.00 | 417.00 | 0.054311 | 0.069686 | 2013-01-04 00:00:00 |
| variety | spot_price | near_contract | near_contract_price | dominant_contract | dominant_contract_price | near_basis | dom_basis | near_basis_rate | dom_basis_rate | date | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 105977 | WR | 3833.20 | wr2403 | 4230.0 | wr2405 | 3898.0 | -396.80 | -64.80 | -0.103517 | -0.016905 | 2024-03-11 00:00:00 |
| 105978 | HC | 3888.00 | hc2403 | 3826.0 | hc2405 | 3798.0 | 62.00 | 90.00 | 0.015947 | 0.023148 | 2024-03-11 00:00:00 |
| 105979 | FU | 5612.00 | fu2404 | 3200.0 | fu2405 | 3178.0 | 2412.00 | 2434.00 | 0.429793 | 0.433713 | 2024-03-11 00:00:00 |
| 105980 | BU | 3569.43 | bu2403 | 3558.0 | bu2406 | 3620.0 | 11.43 | -50.57 | 0.003202 | -0.014168 | 2024-03-11 00:00:00 |
| 105981 | RU | 13210.00 | ru2403 | 14145.0 | ru2405 | 14180.0 | -935.00 | -970.00 | -0.070780 | -0.073429 | 2024-03-11 00:00:00 |
| 105982 | SP | 6070.00 | sp2403 | 5946.0 | sp2405 | 6002.0 | 124.00 | 68.00 | 0.020428 | 0.011203 | 2024-03-11 00:00:00 |
| 105983 | SS | 13967.50 | ss2403 | 13645.0 | ss2405 | 13770.0 | 322.50 | 197.50 | 0.023089 | 0.014140 | 2024-03-11 00:00:00 |
| 105984 | BR | 13240.00 | br2403 | 13280.0 | br2404 | 13295.0 | -40.00 | -55.00 | -0.003021 | -0.004154 | 2024-03-11 00:00:00 |
| 105985 | SI | 14940.00 | SI2403 | 13155.0 | SI2405 | 13270.0 | 1785.00 | 1670.00 | 0.119478 | 0.111780 | 2024-03-11 00:00:00 |
| 105986 | LC | 111400.00 | LC2403 | 111100.0 | LC2407 | 115100.0 | 300.00 | -3700.00 | 0.002693 | -0.033214 | 2024-03-11 00:00:00 |